package com.neu.wangweili.dao;

import com.neu.commons.Dao.BaseDao;

import java.util.List;
import java.util.Map;

public class W_DorInfoDao extends BaseDao {
//    查询所有的宿舍楼号
    public List<Map<String,Object>> findAllDor(){
        List<Map<String,Object>> list=null;
        String sql="select dor_build" +
                " from t_dor_info" +
                " group by dor_build";
        list=super.BaseDaoQuery(sql);
        return list;

    }
//    根据楼号查询宿舍号
    public List<Map<String,Object>> findByBuild(Object...obj){
        List<Map<String,Object>>list=null;
        String sql="select dor_id,dor_no from t_dor_info where dor_build=?";
        list=super.BaseDaoQuery(sql,obj);
        return list;
    }
}
